Skip to main content

Limitations and considerations

The following limitations apply when using the Snowflake on AWS target endpoint in a Replicate task:

  • Replication of tables with backslashes in their names (for example, SPECIAL\\TABLE\N) is not supported.
  • When Bulk Loading is set as the loading method, the Transactional apply Change Processing mode is not supported.
  • When using Snowpipe Streaming as the loading method, the following limitations apply:
    • As Snowpipe only supports INSERT operations, the Apply Changes replication option will not be available.
    • When the Store Changes replication option is enabled, changes can only be stored in Change tables, not in an Audit table.
    • The Batch optimized apply change processing mode is not supported.
    • Username and password authentication is not supported.
    • The XML subtype is not supported.
    • Stopping Store Changes replication during a transaction and resuming it after 30 days or more might cause duplicate records on target. Snowflake automatically deletes channels after 30 days.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!